package nioexample;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;

/**
 * @author zoush
 * @createTime 2024/12/03  10:46
 */
public class FileChannelTest {
    public static void main(String[] args) throws FileNotFoundException {
//        FileOutputStream fileOutputStream = new FileOutputStream(new File("E:\\test.txt"));
//        fileOutputStream.getChannel();
//        FileInputStream fileInputStream = new FileInputStream(new File("E:\\test.txt"));
//        fileInputStream.getChannel();
        Long i = null;
        if (i==0L){
            System.out.println("true");
        }else {
            System.out.println("true");
        }
    }

    /**
     *
     *
     *
     *
     SELECT  person_id, dept_id,name,COUNT(*) as count
     FROM (
     SELECT
     ROW_NUMBER() OVER (PARTITION BY (CASE  WHEN (t.dept_id is not null ) THEN t1.dept_name ELSE t.affiliated_unit_name END) ORDER BY person_id asc) as rn,
     T.person_id,
     T.dept_id,
     T.affiliated_unit_name,
     t1.dept_name,
     CASE  WHEN (t.dept_id is not null ) THEN t1.dept_name ELSE t.affiliated_unit_name END as name
     FROM
     tem_exam_person
     T LEFT JOIN base_dept t1 ON t1.dept_id = T.dept_id
     WHERE t.deleted = 0
     ) example_table
     WHERE rn =1
     GROUP BY person_id, dept_id,name
     */
}
